UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qu+nRI9EdUJ9FWVF9K52szoD21aCdAMDoMTL2qv3stE='
WHERE
key_id = 'dd2ca6a62f1cea07213b18141905b805169754985bf1bad39000eb5580cae334'
AND (
token = 'Qu+nRI9EdUJ9FWVF9K52szoD21aCdAMDoMTL2qv3stE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)