UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xAqRPtZLLA+RQRJHRAm4sF1WPUn1XkuliMx/cI3t9Ns='
WHERE
key_id = 'a7905a06c9d5ae92c4f78d63c95f4cc5b5ffb454b0f1edcdf6a87f2395a27998'
AND (
token = 'xAqRPtZLLA+RQRJHRAm4sF1WPUn1XkuliMx/cI3t9Ns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)