UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qwnjVzKfGq3OsRjCNcruhHFUlrW6qZ6YFsvduxf4Pr4='
WHERE
key_id = '46fbe22424cf40379524abba1cfcd247709f1d40b892c81ea5c5f89411046678'
AND (
token = 'qwnjVzKfGq3OsRjCNcruhHFUlrW6qZ6YFsvduxf4Pr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)