UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sbI+BUc6RVjiAXXORE6KOZtL71ufFPHgLdBBQsuOFuM='
WHERE
key_id = '9309006376095c4aed961077f39486deadb1afa01ec31c4b847df825ba02af49'
AND (
token = 'sbI+BUc6RVjiAXXORE6KOZtL71ufFPHgLdBBQsuOFuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)