UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M+YMCBFL4bymVsMa9AvwV7bJh5PRPG8oQufellvaIy8='
WHERE
key_id = '0dc77cc9fe0fa3199691f2f34423887ae219f40871e72ce2fe7bf1570b2cbbe7'
AND (
token = 'M+YMCBFL4bymVsMa9AvwV7bJh5PRPG8oQufellvaIy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)