UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hcbTbrM/hwFezXVBjKtmX/x7gJE/W0jLOoxRirp20EE='
WHERE
key_id = '1a9dce5d71f88e22800c77696d2a1c5f330e986a95f122e0b133c01dcdb12dfe'
AND (
token = 'hcbTbrM/hwFezXVBjKtmX/x7gJE/W0jLOoxRirp20EE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)