UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KKRKpkC/8D5hapt7SHdEoyxsMW9IRjB0T8GJx8MJ7PA='
WHERE
key_id = '4a273afc4ae2a0e84a06e7da67a138c5c104d3b5cd052c6f5cefbc6a1a7225b4'
AND (
token = 'KKRKpkC/8D5hapt7SHdEoyxsMW9IRjB0T8GJx8MJ7PA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)