UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KIPiAQx6oINUNHCerkf0CBWK9nndG1+BeN9G4bbKqr8='
WHERE
key_id = '40e38849c1838260623aa145a1796d6fefb531b21a51dfbc9f8d699cd0366179'
AND (
token = 'KIPiAQx6oINUNHCerkf0CBWK9nndG1+BeN9G4bbKqr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)