UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CMSwXpEwLYCb/BS5lORdffnFil6Ig4li6OEcoFcMtLc='
WHERE
key_id = 'fed8051cd205c99d5d2087d76eabf294d0fe7c78be2f6a7c7b656ed31be8b647'
AND (
token = 'CMSwXpEwLYCb/BS5lORdffnFil6Ig4li6OEcoFcMtLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)