UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JkeBjmHcnlyq8Sbscl3rTr8NFvcSsKUlYqRZk6/adqo='
WHERE
key_id = '0983a351c261c1f18fee46afb68d15d892c7d04652ea750391fff43fa1a066b5'
AND (
token = 'JkeBjmHcnlyq8Sbscl3rTr8NFvcSsKUlYqRZk6/adqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)