UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0iYt0FetQbTdjmbxwi3Edd+oFJ+aA46ijPZ/UgsQI8c='
WHERE
key_id = 'e32189ff4d46b982af488bb908ffda6255490b19d1ef8d1d63fefdeb5277c3e5'
AND (
token = '0iYt0FetQbTdjmbxwi3Edd+oFJ+aA46ijPZ/UgsQI8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)