UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cV48VGiAAP8ZmdvCdiMrcfvhSpK5hExz7RrRebCaiwI='
WHERE
key_id = '410a3e2eb2d2a4768b037ede82225b07aa89624dbca47bf2322fceaf5f0d103c'
AND (
token = 'cV48VGiAAP8ZmdvCdiMrcfvhSpK5hExz7RrRebCaiwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)