UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0BAyGa0AAc7bvGQeJS0H5km62jeAaORmI41p/J55hkc='
WHERE
key_id = '6c741a55d7eeb1b64a50efa016b71b52436d739519353e92f1bf4d4219cd0778'
AND (
token = '0BAyGa0AAc7bvGQeJS0H5km62jeAaORmI41p/J55hkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)