UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6IZu8379mstpcTt0cB3lHiRLjRpeRxhjsD/oB2GUG+M='
WHERE
key_id = '6646b0d8e41971c1d583c0ca8259187eac0f4bd402e83d75c1ba924cbc970199'
AND (
token = '6IZu8379mstpcTt0cB3lHiRLjRpeRxhjsD/oB2GUG+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)