UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9K7XFiRkoWrV8aa3wkBosAczZFD9mEC45Sj1RwKWpTU='
WHERE
key_id = 'ce67ca8a9f0e7f921b0e23a92cf1aeff54da344aca8f331ac7a0da1234b98b64'
AND (
token = '9K7XFiRkoWrV8aa3wkBosAczZFD9mEC45Sj1RwKWpTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)