UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xPRzeH9WNN827dn2mf6Yvhy2fqFLUIWWxy7rylrBCY='
WHERE
key_id = 'b066ae027df36406c9637bc92100095f962ff98130868ca5a8f54fa640f9859f'
AND (
token = '0xPRzeH9WNN827dn2mf6Yvhy2fqFLUIWWxy7rylrBCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)