UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DhDagAzf/5jaVwZveDwG2eSJ3ImsxOEt+rd43VFOyjM='
WHERE
key_id = '99d3e6fd766b5aaf10392b9b9530717865cf6708a577fd380140754fd5d614ec'
AND (
token = 'DhDagAzf/5jaVwZveDwG2eSJ3ImsxOEt+rd43VFOyjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)