UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PD1PpZDuokqw2g6qxDIFTN8QsDKug1z/pypS2JeUxjQ='
WHERE
key_id = '271a49744844898b8d8078b252e75fd4c9f1f7289b5e31594cfb9f116a11878b'
AND (
token = 'PD1PpZDuokqw2g6qxDIFTN8QsDKug1z/pypS2JeUxjQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)