UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dG9Zx7bJzltBKkOgy/j/PYGmUk4gxb6NL3qf4R6m2rQ='
WHERE
key_id = '6ffe9ef14d3c9347358999147a0ea3282b852eef506a666ea74c1305c3815fe3'
AND (
token = 'dG9Zx7bJzltBKkOgy/j/PYGmUk4gxb6NL3qf4R6m2rQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)