UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/IjiSY28j4YvVEcMx7qNWJFN3Xgs4E8q0iLay9+s9jI='
WHERE
key_id = 'f15f0b486cb4ee03140316327eb24067517fae51e572006507ab8e924e71f92c'
AND (
token = '/IjiSY28j4YvVEcMx7qNWJFN3Xgs4E8q0iLay9+s9jI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)