UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZAzTF2YDeJcpSDLazkci787ycyx5rCt1/pPe/Kbeuo8='
WHERE
key_id = 'f40b4436612923b0c43a89aa99876029c34ebc6e55e6544d496c0ccdaad17bd5'
AND (
token = 'ZAzTF2YDeJcpSDLazkci787ycyx5rCt1/pPe/Kbeuo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)