UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'du/eDmNsUa1lB0DPSXsPFm372+2iHFvBKjVrNPiFqiA='
WHERE
key_id = '59c676fec73f92a6713eb8d6f25888920da6f227b348ef500ac0b7d51908f255'
AND (
token = 'du/eDmNsUa1lB0DPSXsPFm372+2iHFvBKjVrNPiFqiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)