UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SOm4LcJcIti1hnRYT6ZiNXrrjsPD2jvzqvdu6bDqkhc='
WHERE
key_id = '3dba713025307e9ca8c5c7151af2fa5858443844ed954c2d011ab3f7c08b0f64'
AND (
token = 'SOm4LcJcIti1hnRYT6ZiNXrrjsPD2jvzqvdu6bDqkhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)