UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xY8JOHsVXOfpdLHmaINMJ6Bk3QP06djnMCbOtQKFO2I='
WHERE
key_id = 'c11911e1bd35fc02d03bddcd22f7576093313382c25fd0b868d1f8ef936ea844'
AND (
token = 'xY8JOHsVXOfpdLHmaINMJ6Bk3QP06djnMCbOtQKFO2I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)