UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H4IC8atAQITckvTXpnCoyJeghAIAf4onq+rXlMvxdHE='
WHERE
key_id = 'cb9f4cf3e88a5d0735fe4b8dfcb6880aa65f68afefc7affb30d88c3c55555d1e'
AND (
token = 'H4IC8atAQITckvTXpnCoyJeghAIAf4onq+rXlMvxdHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)