UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lAEiAp6pZ2KeJRPPNGK5PEENoPJ5M1WltgdV/5OCSD0='
WHERE
key_id = '5a587a7c721d0f3eb6181fe54cfa034fd63a867f0bccfd3c20245f55932ee968'
AND (
token = 'lAEiAp6pZ2KeJRPPNGK5PEENoPJ5M1WltgdV/5OCSD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)