UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ErXcGTy9ev4c1cMFvV0Iqso3E+1VS+ocqOEm/qcBI4E='
WHERE
key_id = 'c538b74d41c22650fb62bcf1614bd6a7aa720556bffcf77ab6e5c7f6f4744dad'
AND (
token = 'ErXcGTy9ev4c1cMFvV0Iqso3E+1VS+ocqOEm/qcBI4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)