UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tPWvwr8xl9i5W1xboxBb1WG9KkULn+yiP2WHx37wdbY='
WHERE
key_id = 'abbe89c6ae5b34f2510f50ee656047670a66b952224ecf93ba2a24c35375bff7'
AND (
token = 'tPWvwr8xl9i5W1xboxBb1WG9KkULn+yiP2WHx37wdbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)