UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yj679ZdlWZIYj53E7SvpV78oRmVpB9Rg6SmFM939tWU='
WHERE
key_id = '729ec4294e1f27792aeb16287a61ce6d9ef993dabe7f41f9bba42df9416ea7cd'
AND (
token = 'yj679ZdlWZIYj53E7SvpV78oRmVpB9Rg6SmFM939tWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)