UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cnr4rc0I+LMzCzCTQBPM9Tu8cSfZNz9jNsCrUsjrc/A='
WHERE
key_id = 'c9d2d6c9f0a316bd300f80eb3689aee3ecde1789bb345cbd8a442eed75501a38'
AND (
token = 'Cnr4rc0I+LMzCzCTQBPM9Tu8cSfZNz9jNsCrUsjrc/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)