UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xuv16J9sFE3V0bOGaLsAlFXjXlFDXtmUmlcB3yk5PH4='
WHERE
key_id = 'c42cb396d2e4337d641e8583b45b8d11675d9481feab2feb593e4097f0d13838'
AND (
token = 'Xuv16J9sFE3V0bOGaLsAlFXjXlFDXtmUmlcB3yk5PH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)