UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cmqGRmyiMi3BDEKgZq8cIhdlA4uZRszHhOQzs0AcdKE='
WHERE
key_id = 'a3ed1f3ee05c953c171976aa1ba7bd09e9d63d057b93a1b1d9e59276a692aaa8'
AND (
token = 'cmqGRmyiMi3BDEKgZq8cIhdlA4uZRszHhOQzs0AcdKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)