UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Oc5sIY27tWErqB1CEoBIbcbsTPbwQly0/6ZGyDPU2Pc='
WHERE
key_id = 'e73fafe7c5593af24fb5b0b965c72632d6c2e32bfd962aa91faf108094c90ec9'
AND (
token = 'Oc5sIY27tWErqB1CEoBIbcbsTPbwQly0/6ZGyDPU2Pc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)