UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBtuyCGXRE2NmQLlwa3belVbCm7ex5KXGqpj7dDj1Zg='
WHERE
key_id = '0c065225f1f340b6664994b28c6c7b553a8662427613329a553acc1c0364863f'
AND (
token = 'XBtuyCGXRE2NmQLlwa3belVbCm7ex5KXGqpj7dDj1Zg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)