UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nMyaXiZlLLREMzbBA46N3gyMnXlKI/1dr7p1aHODBrs='
WHERE
key_id = '47de5b3ff4fe3ecd27a0717a6cc023ada802eaf5e2409c8657523c3517b97f60'
AND (
token = 'nMyaXiZlLLREMzbBA46N3gyMnXlKI/1dr7p1aHODBrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)