UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd6sUAUZXVy+qmE7k3ArF8flF36jmCgBsmMbyqN3cWAw='
WHERE
key_id = '4c1fc865ac4101064310d648691d984ccdcf6221d9f3809554ebca98abd95920'
AND (
token = 'd6sUAUZXVy+qmE7k3ArF8flF36jmCgBsmMbyqN3cWAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)