UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qe0ZJUNPBVSdiLybPVarsBUwJcpVtE0MkBmz0s3HPVA='
WHERE
key_id = '57cf2a9d25d56930da870530cdbdbc0ec86accbc88e291d2ac1fa358ba44c656'
AND (
token = 'qe0ZJUNPBVSdiLybPVarsBUwJcpVtE0MkBmz0s3HPVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)