UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'og9DVJNA5R4/oO/s2dyF13wRFP9lK7B8y/dHzByg8cE='
WHERE
key_id = '4e7ec4f16bd01cfc89eb4166049e7092d43cc9165dfc575c4f09e49b891b1a82'
AND (
token = 'og9DVJNA5R4/oO/s2dyF13wRFP9lK7B8y/dHzByg8cE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)