UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ev/VTqD3lPaW8mP2/sR7khKt7h+UfVuDAbIH89st1oc='
WHERE
key_id = '30d8b8fcef6fafc95ce48ce7da2584694d513ea345e2b10fe34f4f1fdb6553e5'
AND (
token = 'Ev/VTqD3lPaW8mP2/sR7khKt7h+UfVuDAbIH89st1oc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)