UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ifrcB9TZG7fPdrqVn5VqUX+3cQSWl2BUEMvDi/IGHQ0='
WHERE
key_id = '0d6ccaf8ce1f88e095cb5c78ec1b18340fd5be6fe5f1efff42cf77d3bfd33e21'
AND (
token = 'ifrcB9TZG7fPdrqVn5VqUX+3cQSWl2BUEMvDi/IGHQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)