UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1tQ4v9YyhIip9gxj1QPA/1Y4XyfWXzG6CqriQMlKZSU='
WHERE
key_id = 'cfc2a5227c1ec30565a1492eb35e1eacfaa173a247714a48ebff55a772af342d'
AND (
token = '1tQ4v9YyhIip9gxj1QPA/1Y4XyfWXzG6CqriQMlKZSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)