UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GMuXi+g1QrmxMsX+1yW867b6kL9S8ABvX6UYYOzS6mo='
WHERE
key_id = '5b1506c2fc0d81d94ecb32c5aa0552b47bf64417e94b9aaa56a486a09579539f'
AND (
token = 'GMuXi+g1QrmxMsX+1yW867b6kL9S8ABvX6UYYOzS6mo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)