UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'snXKZQQFpjsMsgPr7hoKZ2XW7pd6HTQPjWRiWQNfvQQ='
WHERE
key_id = 'dd727d84748089e30c5d4a30c3b8924cafee843c30cfe26734726c3ba810ee51'
AND (
token = 'snXKZQQFpjsMsgPr7hoKZ2XW7pd6HTQPjWRiWQNfvQQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)