UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Ph1K5uuFPv30Tqn9uVk+YAmk+wv/g9FvqhTcCedQo4='
WHERE
key_id = '55541c84071e5d28069d34b7f401f83a16bc89f1cadbfefbc867b33756e20528'
AND (
token = '8Ph1K5uuFPv30Tqn9uVk+YAmk+wv/g9FvqhTcCedQo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)