UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CKbvgaBWe3Gqg71VqUTWjjX6IUrq0QbJjSghcbjr48o='
WHERE
key_id = '23e95fd48d4b8365b9361fffe510887d806b465b4c49fb188ffcf5ed44ca5d90'
AND (
token = 'CKbvgaBWe3Gqg71VqUTWjjX6IUrq0QbJjSghcbjr48o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)