UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ooiXFd8i0SKG0JwDKVRF8d2vqMfqeaCgpr6/5tyaq+k='
WHERE
key_id = 'e9f8fae03c4ce97128a2ad88c6a55b73cab35973d3e3de75fc97e808f3c13323'
AND (
token = 'ooiXFd8i0SKG0JwDKVRF8d2vqMfqeaCgpr6/5tyaq+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)