UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LSsWY7CtcbbSdg1IStNtFLaPjSKU8mpW4iv2CNB7V+0='
WHERE
key_id = '7e9a4114f9f91c3dab009add109931caf9096624047f53d89d6940cf32024661'
AND (
token = 'LSsWY7CtcbbSdg1IStNtFLaPjSKU8mpW4iv2CNB7V+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)