UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iQJGtEj8fj3Gq4G2KZ0/1umleBoc7OUTrt90D0bwBWw='
WHERE
key_id = '5455e66616982a3c555f4583b8861503661797ffe40c528a12ff4f158842a12e'
AND (
token = 'iQJGtEj8fj3Gq4G2KZ0/1umleBoc7OUTrt90D0bwBWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)