UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VYKjIx2LFbRMNNds5UsOC4d5ofoM644j5v8t7ntt7H0='
WHERE
key_id = 'afb172ab641799dd8d916a07c8e214055ef4ce8898db00d6624482885965bbee'
AND (
token = 'VYKjIx2LFbRMNNds5UsOC4d5ofoM644j5v8t7ntt7H0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)