UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dfnWnmA4J1v58fvnHqAh/po4nHGu7aL24wmkXn0OicA='
WHERE
key_id = 'ec9c826ffdb236e8a90d52b2d6f79879a91744f2b81ac16d763e4cdd108ef09e'
AND (
token = 'dfnWnmA4J1v58fvnHqAh/po4nHGu7aL24wmkXn0OicA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)