UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5qi7yT7nsvXbdnflmvXP6jeAiBAJT657gOiRAGHLgCI='
WHERE
key_id = 'f003765c79ea4aea5df0844b07ef7f81333a77a67d47be02342ef9ef7d125cda'
AND (
token = '5qi7yT7nsvXbdnflmvXP6jeAiBAJT657gOiRAGHLgCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)