UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6CGIRCO+4mlCMtPWrb6gTLlz61wYsLTrP+AUbZnv/QU='
WHERE
key_id = '603c26f4e4b024684f0a796ff5224a5544098c7c314922a1b42c337e4b5a7dae'
AND (
token = '6CGIRCO+4mlCMtPWrb6gTLlz61wYsLTrP+AUbZnv/QU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)