UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RUoXi9ETWfBrumQWc6/3FN+olkBP7GkkuITDM2KR6n8='
WHERE
key_id = '5edf34c9abbe74a9a83f81099f4486a72171da8557b12ecc061f2a13933f7da8'
AND (
token = 'RUoXi9ETWfBrumQWc6/3FN+olkBP7GkkuITDM2KR6n8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)