UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7dEzE4CUr4J3yltG/YJ5DnpYjdio00uM6fsfm4ov02c='
WHERE
key_id = 'd9a1907f146a41fab81b56d6835ddb831060769c2192436bf4547fc39a8d7c87'
AND (
token = '7dEzE4CUr4J3yltG/YJ5DnpYjdio00uM6fsfm4ov02c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)