UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aDX8YsEPfn9D8LjVpKR5fpAOCEsjzNIEtRgapzw+njw='
WHERE
key_id = '8274aafac455aa49ff0ae2694b7be1afa21beca90f634497b22e17270224e3dc'
AND (
token = 'aDX8YsEPfn9D8LjVpKR5fpAOCEsjzNIEtRgapzw+njw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)