UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's6c65iz9uADx78ihaUiGG7hGYWEZOnampm4KUHer/Dw='
WHERE
key_id = 'af4b9999257c81ee2c71e6a6052681070f88adab38c8969e50e1546dfb976c58'
AND (
token = 's6c65iz9uADx78ihaUiGG7hGYWEZOnampm4KUHer/Dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)