UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJpFIjjJTsTcsyzWuc1C5vLJIo7rs/hFkFn6uu6PlvI='
WHERE
key_id = 'c6b2e3e125994a0d6588acb8c025f8c8a8a4487674e459f10a951abd8ae8d198'
AND (
token = 'BJpFIjjJTsTcsyzWuc1C5vLJIo7rs/hFkFn6uu6PlvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)