UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vcHd1V/GwAdgtC2f0AkYjHz/No08k8OyXDWQ1cY80Us='
WHERE
key_id = '1ea940870df1f0b821dd7ff36ae528515f30c418a528864db240812916914056'
AND (
token = 'vcHd1V/GwAdgtC2f0AkYjHz/No08k8OyXDWQ1cY80Us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)